SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms='3') and (bedrooms='3')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 15
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:Charming, inviting, and wonderfully connected to all that Lyme has to offer, this village home pairs classic New England character with beautiful western views and an exceptional Upper Valley location. Set on spacious grounds overlooking protected conservation land, the property enjoys an open sky and memorable sunsets that will remain part of the view for years to come. Inside, the home offers 3 bedrooms, warm and comfortable living spaces, and the character that makes an older home feel special. A screened porch becomes an extension of the living space for three seasons, perfect for morning coffee, summer dinners, or relaxing at the end of the day. Mature sugar maples, a generous yard, and a barn offering storage for bikes, skis, tools, and more add to the property’s appeal. Recent investments in a substantial solar array, heat pumps for heating and cooling, and a heat pump hot water heater bring modern efficiency to this classic home. It was just recently repainted inside and out making it move-in ready. Located at the edge of Lyme village, everyday conveniences are just a short stroll away, while outdoor recreation is equally accessible. Walk to Grant Brook for a summer swim, hike Lyme Pinnacle from the backyard, launch a kayak on the Connecticut River, or head to nearby Dartmouth Skiway and the Greens for winter adventures. All this within easy reach of Hanover and Dartmouth, and with access to the highly regarded Lyme/Hanover school system. Just 25 min to DHMC, 15 min to Dartmouth college, 2h 15min to Boston. A special opportunity to enjoy village convenience, country charm, beautiful views, and the quintessential Upper Valley lifestyle.
Description:Enjoy the comfort and convenience of this newer 2023 built home, ideally located on a paved dead end street in the Village. From the moment you step inside, this home has the wow factor, with a bright, open layout and thoughtful finishes throughout. The impressive kitchen is the centerpiece of the main level, featuring granite countertops, a large breakfast island, under-cabinet lighting, and stainless steel appliances. The kitchen flows seamlessly into the living areas, creating a welcoming space for everyday living and entertaining. Doors lead directly to the wraparound deck, extending the living space outdoors. The fenced in lawn provides a great space for pets, play, or simply relaxing at home. The home features modern bathrooms on first and second level, including a spacious primary suite with its own full bath and walk-in closet. An impressive extra-wide, 4-foot staircase leads to the second floor, where conveniently located laundry adds to the home’s thoughtful and functional design. The partially finished basement provides additional usable space with plenty of potential, while the one-car garage adds even more convenience. Located just steps from the rail trail and abutting to the Mascoma River, with an easy commute to Dartmouth Hitchcock Medical Center and the Upper Valley, this impressive home combines newer construction, a great layout, outdoor living, and a location that is hard to beat.
Description:OPEN HOUSE - SATURDAY 8/29 from 10-12. Welcome to your private country sanctuary. Situated on 3.2 peaceful, scenic acres in a highly desirable area, this beautifully maintained 3-bedroom, 2-bathroom residence offers over 1,700 square feet of comfortable, move-in-ready living space. Inside, you will find a bright and spacious layout designed for modern comfort, featuring generous living areas filled with natural light, a Rinnai on-demand system for ample hot water, and picturesque views of the surrounding grounds from every room. The kitchen shines with sleek granite countertops, custom cabinets with slide-out drawers, and ample pantry-style storage, highlighted by an replica Elmira 1865 dual-fuel cooking stove (available as a negotiable inclusion).Outside, the property is a true hobby farmer’s or equestrian’s dream, anchored by an exceptional 3-stall Amish-built barn complete with water and electricity, along with an adjacent fenced-in paddock ready for horses or livestock. The meticulously landscaped parcel features a prominent stone retaining wall, vibrant established perennial garden beds that bloom year after year, and mature sugar maples ready for seasonal tapping. Despite the serene and secluded setting, you are never far from everyday necessities and year-round adventure: enjoy quick access to shopping, local public services, and a favorite nearby swimming hole, with premier skiing just 10 miles away and regional hospital services and dining destinations within an easy 20-minute drive. Whether you are looking for an active homestead, equestrian property, or a quiet retreat close to modern conveniences, this turnkey country home offers an exceptional lifestyle opportunity.
Description:Privacy, convenience, and beautifully updated living spaces come together in this inviting Lebanon home. Set on approximately 0.7 acres in an established neighborhood, the property enjoys a wonderfully private setting while remaining just minutes from downtown Lebanon, shopping, dining, recreation, Dartmouth Hitchcock Medical Center, and the many amenities of the Upper Valley. Inside, the updated kitchen and baths bring a fresh, polished feel to the home, complemented by a comfortable and functional floor plan designed for everyday living. Three bedrooms provide flexibility for family, guests, or a dedicated home office, while the finished lower level expands the possibilities with additional space for a family room, fitness area, hobbies, work-from-home needs, or guest overflow. An enclosed porch creates another inviting place to relax and enjoy the surroundings, while the attached two-car garage adds convenience through every New England season. Outside, the generous lot provides breathing room, privacy, and space to enjoy the outdoors without the upkeep of a much larger property. With thoughtful updates, flexible living space, a private setting, and excellent proximity to downtown Lebanon and the Upper Valley’s major employment and recreation centers, this home offers an appealing balance of comfort, convenience, and location.
Description:Welcome to 793 Shaker Hill Road - an inviting 3-bed, 2-bath home situated on 2.25 acres in the heart of Enfield. Offering a wonderful blend of modern comfort, character, and convenience. The spacious great room is a standout feature, complete with a grand fireplace that creates a welcoming gathering space. The tasteful kitchen features granite countertops, solid wood cabinetry, and plenty of room for preparing and enjoying meals. Outside, the back deck and fully-fenced yard provides space to relax, play, garden, or simply enjoy the peaceful New Hampshire surroundings. Located near Crystal Lake, Shakoma Beach, the Shaker Inn & Museum, and the Enfield Dog Park. A comfortable home, a beautiful setting, and a desirable Enfield location - this property is ready to welcome you home. A quick commute to Dartmouth, DHMC, and the Greater Upper Valley of NH and VT. Open House: Saturday Aug. 15, 10am-1pm
Description:Charming 1949 lakeside ranch offers a rare blend of classic character just steps from Crystal Lake, known for its clear waters, recreation, and year-round beauty. Set directly across the street from the lake, the home is paired with an additional attached parcel on the water. Inside, the home features three bedrooms and two baths, with a warm, functional layout that reflects its mid-century roots. A partially finished basement adds valuable flexible space, ideal for a family room, home office, or guest overflow. Large windows invite in natural light, while the setting provides stunning lake views and a peaceful atmosphere.
Description:Discover easy, one-level living in this beautifully renovated three-bedroom, two-bath condominium at The Falls. Thoughtfully updated throughout, this home offers a versatile floor plan with plenty of space to relax, work, and entertain. The third bedroom can easily serve as a private home office, den, or guest room to suit your needs. The spacious living area opens to a large outdoor deck with two distinct seating areas, creating an inviting extension of the home for outdoor dining or gathering with friends. A two-car attached garage adds convenience and provides direct access to the home. Enjoy the amenities of The Falls, including a beautiful in-ground pool and a charming community orchard at the top of the hill, offering a wonderful setting for picnics and enjoying the outdoors. Centrally located, this property is just 10 minutes from Dartmouth College and Dartmouth Health, with shopping, dining, and everyday conveniences close by.
Description:Situated on 65 country acres, discover the potential that this 3 bedroom, 1 bath antique Cape holds. The property features a large barn, a two car garage, open fields, a mature apple orchard, berry bushes and flower gardens, which offers endless possibilities for farming, recreation, or peaceful country living. While the home is in need of some work, it offers a wonderful opportunity to restore a classic New England Cape and truly make it your own. Conveniently located near Crystal Lake, Mascoma Lake, Grafton Pond and several walking/hiking trails. Open House: Saturday 8/15 10am-12pm.
Description:Just a short walk from Dartmouth College, this classic New England home offers comfort, convenience, and the option of long-term rental income. Currently leased through June 2026, it’s an excellent investment opportunity or future personal residence in a highly sought-after location. Featuring 3 bedrooms and 1.5 bathrooms, the home combines traditional character with practical updates. The kitchen opens to a bright dining area overlooking the peaceful, protected woods behind the property—perfect for enjoying the changing seasons in privacy. A spacious deck extends from the side of the house, ideal for outdoor dining or relaxing in nature. The home’s convenient layout includes a cozy living space, plenty of natural light, and laundry in the basement. Located within walking distance of campus, local shops, and restaurants, this property offers the best of Hanover living—with everything you need close by. Listing agent has an ownership interest in the property.
Description:Own a piece of early New England history with waterfront - a rare combination that almost never comes available. This iconic 1812 stone home sits on a level 0.98-acre lot and includes 130 feet of owned Connecticut River frontage just across the quiet country road, offering easy access for kayaking, fishing, paddle boarding, or simply enjoying the ever-changing water views. Inside, the home blends historic character with comfortable living. The first floor offers a warm and inviting living room with wood stove, country kitchen with dining nook, formal dining room, first-floor bedroom, half bath, sun porch, workshop space, and generous storage. Upstairs you'll find a large primary bedroom, office, and full bath, while the third level provides an additional bedroom and flexible bonus space perfect for guests, studio, or work-from-home use. Original details remain throughout - maple floors on the main level, wide pine floors above, and deep farmhouse window trim - creating the charm only a true period home can offer. Outside, the property is equally special, with mature landscaping, established garden areas, patio space, and a workshop/shed. The river frontage across the road expands the lifestyle, giving you your own personal access to the Connecticut River without sacrificing privacy at the house site. Conveniently located just minutes to I-91 and an easy bike ride to Post Pond and Cedar Circle Farm, this property offers a unique blend of history, recreation, and rural tranquility - a setting increasingly difficult to find in the Upper Valley. Just a 20 minute drive to downtown Hanover & Dartmouth College. High School Choice.